package com.cnswhy.cloud.server.core.dao;

import com.cnswhy.cloud.common.core.base.mapper.SuperMapper;
import com.cnswhy.cloud.server.core.dto.SpreadLogBo;
import com.cnswhy.cloud.server.core.entity.SpreadLog;

import com.cnswhy.cloud.server.core.vo.SpreadVo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * Mapper 接口
 * 
 * </p>
 *
 * @author cnswhy
 * @date 2020-09-30
 */
@Repository
public interface SpreadLogMapper extends SuperMapper<SpreadLog> {
    SpreadVo queryCustomerSpread(Long customerId);
    Map<String, Object> subTotalAmount(SpreadLogBo bo);
    @Select("select * from t_spread_log where id in (10452,10425,10380,10524,10557,10479,10587,10588,10480,10558,10525,10526,10559,10481,10589,10590,10482,10560,10527,10591,10528,11688,11660,11724,11662,11690,11726,11691,11727,11692,11663,11694,116665,11695,11728,11697,11730,11698,11731,11700,11733,11702,11734,11703,11735,11705,11737,11667,11644,11711,11765,11810,11752,11789,11811,11812,11790,11814,11791,11792,11815,11807,11793,11794,11816,11808,11781,11809,11805,11848,11849,11850,118551,11862,11916,11852,11863,11854,11917,11855,11864,11856,11866,11918,11867,11857,11858,11868,11895,11870,11871,11896,11872,11897,11898,11873,11899,11900,11837,11860,11901,11914,11874,11934,11938,11940,11941,11942,11943,11962,11945,11946,119633,11964,11952,11988,11979,11953,11965,11954,11980,11989,11955,11956,11990,11957,11958,11927,11960,12005,11981,11991,11977,11986,12007,12008,11999,12004,12044,12045,12059,12060,12026,12027,12028,12029,12030,12032,12047,12024,12082,12086,12150,,12198,12151,12199,12152,12200,12153,12201,12154,12202,12155,12156,12204,12157,12158,12159,12205,12160,12162,12163,12164,12166,12167,12168,12206,12169,12171,12172,12173,12174,12207,12148,12196,12389,12391,12392,12394,12387,11754,11713,11714,111755,11757,11715,11716,11758,11718,11756,11719,11709,11708,11720,11707,11722,11706,11723,11704,11701,11699,12721,12723,12725,12766,12726,12768,12728,12730,12732,12733,12735,12736,12738,12740,12769,12771,12741,12773,12743,12745,12746,12749,122752,12754,12756,12719,12764)")
    List<SpreadLog> getDumplate();

}
